<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Creating a filter within a report: Embedded filters</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ol.whs2 { list-style:decimal; }
img_whs3 { border:none; width:18px; height:16px; float:none; border-style:none; }
ul.whs4 { list-style:square; }
p.whs5 { font-style:normal; }
img_whs6 { border:none; width:17px; height:17px; float:none; border-style:none; }
img_whs7 { border:none; width:19px; height:18px; float:none; border-style:none; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying reports\nRetrieving specific data from sources: Filters\nCreating a filter within a report: Embedded filters");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Creating a filter within a report: Embedded filters</h1>
<p>Filters can be added to reports in two ways:</p>
<ul type="disc" class="whs1">
	
<li class=p><p>If a filter object has already been created in your 
 project (this is a stand-alone filter) that you want to use on the report, 
 you can add that filter to the report. To add an existing filter to a 
 report, see 
<a href="Creating_a_filter.htm">Adding a stand-alone filter 
 to a report</a>.</p></li>
	
<li class=p><p>You can create a filter directly in the report. However, 
 this kind of filter cannot be used as a filter on other reports.</p></li>
</ul>
<p>This topic explains how to create a filter within a report. For a comparison 
 of both types of filters, see 
<a HREF="WhatAreFilters.htm">About filters</a>.</p>
<p>Filters can be created as part of a given report, at the same time the 
 report itself is being created. You can filter data based on any object 
 that is part of the report’s definition. You can also use the results 
 of another report as the filter for this report. The conditions specified 
 by the report's filter are part of the SQL that retrieves the report result 
 set from your database. </p>
<h2>To create a filter within a report</h2>
<ol type="1" class="whs2">
	
<li class=p><p>Open the report you want to create a filter for. From 
 the <span style="font-weight: bold;"><B>Home </B></span>menu, select <span style="font-weight: bold;"><B>Design 
 mode</B></span>. </p></li>
</ol>
<ol start="2" type="1" class="whs2">
	
<li class=p><p>If the Report Filter panel is not displayed above the 
 report, click the <span style="font-weight: bold;"><B>Filter</B></span> icon 
 <img src="images/reportfilter.gif" x-maintain-ratio="TRUE" width="18px" height="16px" border="0" class="img_whs3">.</p></li>
	
<li class=p><p>Select the object you want to base your filter on:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>To base your 
 filter on an object that is part of the report's definition, use the Report 
 Objects pane on the left and select the object you want to base your filter 
 on. The object can be an attribute or a metric.</p></li>
		
<li style="list-style: disc;" type=disc class=p><p>To base your 
 filter on the results of another report, select the All Objects pane on 
 the left to navigate to and select the report you want to base your filter 
 on.</p></li>
	</ul>
	
<li class=p><p>Right-click the object and select <span style="font-weight: bold;"><B>Add 
 to Filter</B></span>.</p></li>
	<ul type="disc" class="whs1">
		
<li class=p><p>If DHTML is disabled, select the object and click 
 <span style="font-weight: bold;"><B>Add</B></span>.</p></li>
	</ul>
	
<li class=p><p>Depending on the type of object you added to the filter, 
 a new set of choices may appear. The links below provide steps to filter 
 data on the object you chose:<br>

	<br>

	If you are filtering based on an <span style="font-weight: bold;"><B>attribute</B></span>, 
 see one of the following:</p></li>
	<ul type="square" class="whs4">
		
<li class=p><p>
<a href="att_form_qualification.htm">Filtering data 
 based on attribute forms: Attribute form qualification</a></p></li>
		
<li class=p><p>
<a href="Filtering_on_attribute_elements.htm">Filtering 
 data based on attribute elements: Attribute element list qualification</a></p></li>
		
<li class=p><p>
<a href="filter_on_dates.htm">Filtering data based 
 on dates</a></p></li>
	</ul>
	
<li style=" font-style: normal; " class=p><p class="whs5">If 
 you are filtering based on a <span style="font-weight: bold;"><B>metric</B></span>, 
 see 
<a href="Filtering_on_metric_values.htm">Filtering data based on metric 
 values or rank: Set qualification</a>.</p></li>
	
<li style=" font-style: normal; " class=p><p class="whs5">If 
 you are filtering based on the results of another report, see 
<a href="Report_as_filter.htm">Filtering 
 data based on report results: Shortcut-to-a-report qualification</a>.</p></li>
	
<li class=p><p>Click the <span style="font-weight: bold;"><B>Apply</B></span> 
 icon <img src="images/apply.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs6"> to apply your new filter condition to the report.</p></li>
	
<li class=p><p>You can add additional conditions to the report's filter 
 by repeating the steps above to add another object to the filter and define 
 the condition.</p></li>
	
<li class=p><p>To run the report, click the <span style="font-weight: bold;"><B>Run 
 Report</B></span> icon <img src="images/runreport.gif" x-maintain-ratio="TRUE" width="19px" height="18px" border="0" class="img_whs7">. The report results displayed reflect the new filter.</p></li>
</ol>
<h3>Related topics</h3>
<ul type="disc" class="whs1">
	
<li class=p><p>
<a HREF="WhatAreFilters.htm">About filters</a></p></li>
	
<li class=p><p>
<a HREF="Asking_for_user_input_into_a_filter_s_definition.htm">Asking 
 for user input into a filter's definition</a></p></li>
	
<li class=p><p>
<a HREF="Filtering_data_using_a_filter_object.htm">Filtering 
 data based on an existing filter: Shortcut-to-a-filter qualification</a></p></li>
	
<li class=p><p>
<a HREF="Creating_a_filter.htm">Adding a stand-alone 
 filter to a report</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
